package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_merchant", simpleName = "", engine = MysqlDriver.InnoDB, comment = "商户")
public class _DDL_CMerchant {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.BIGINT_UNSIGNED, nullable = false, comment = "id")
    private java.math.BigInteger id;

    @_DDL_Index(name = "IDX_c_merchant_ag_id")
    @_DDL_Column(name = "ag_id", type = SqlType.INT_UNSIGNED, comment = "渠道商id")
    private Long agId;

    @_DDL_Column(name = "third_id", type = SqlType.VARCHAR, size = 32, comment = "外部商户id")
    private String thirdId;

    @_DDL_Column(name = "name", type = SqlType.VARCHAR, size = 200, nullable = false, comment = "商户名称")
    private String name;

    @_DDL_Column(name = "namec", type = SqlType.VARCHAR, size = 200, nullable = false, comment = "商户简称")
    private String namec;

    @_DDL_Column(name = "area_code", type = SqlType.VARCHAR, size = 10, nullable = false, comment = "区域代码")
    private String areaCode;

    @_DDL_Column(name = "area_name", type = SqlType.VARCHAR, size = 200, nullable = false, comment = "区域名称")
    private String areaName;

    @_DDL_Column(name = "concat_name", type = SqlType.VARCHAR, size = 100, nullable = false, comment = "经办人姓名")
    private String concatName;

    @_DDL_Column(name = "concat_phone", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "经办人电话")
    private String concatPhone;

    @_DDL_Column(name = "concat_address", type = SqlType.VARCHAR, size = 200, comment = "商户地址")
    private String concatAddress;

    @_DDL_Column(name = "ch_id", type = SqlType.VARCHAR, size = 30, comment = "结算渠道id")
    private String chId;

    @_DDL_Column(name = "ch_type", type = SqlType.TINYINT_UNSIGNED, comment = "结算渠道类型")
    private Integer chType;

    @_DDL_Column(name = "pro_id", type = SqlType.INT_UNSIGNED, comment = "当期签约id")
    private Long proId;

    @_DDL_Column(name = "pro_end_date", type = SqlType.VARCHAR, size = 10, comment = "协议结束日期")
    private String proEndDate;

    @_DDL_Column(name = "pro_begin_date", type = SqlType.VARCHAR, size = 10, comment = "协议开始日期")
    private String proBeginDate;

    @_DDL_Column(name = "pro_ag_rate", type = SqlType.DECIMAL, size = 6, scale = 2, comment = "手续费")
    private java.math.BigDecimal proAgRate;

    @_DDL_Column(name = "pro_rate", type = SqlType.DECIMAL, size = 6, scale = 2, comment = "手续费")
    private java.math.BigDecimal proRate;

    @_DDL_Column(name = "pro_type", type = SqlType.VARCHAR, size = 1, comment = "类型")
    private String proType;

    @_DDL_Column(name = "pro_days", type = SqlType.TINYINT_UNSIGNED, comment = "t+n")
    private Integer proDays;

    @_DDL_Column(name = "pro_next_id", type = SqlType.INT_UNSIGNED, comment = "下一期协议id")
    private Long proNextId;

    @_DDL_Column(name = "state", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "内部状态")
    private String state;

    @_DDL_Column(name = "ch_state", type = SqlType.VARCHAR, size = 20, comment = "外部审核状态")
    private String chState;

    @_DDL_Column(name = "reason", type = SqlType.VARCHAR, size = 200, comment = "审核失败愿意")
    private String reason;

    @_DDL_Column(name = "pwd", type = SqlType.VARCHAR, size = 32, nullable = false, comment = "商户登录密码")
    private String pwd;

    @_DDL_Column(name = "refresh_token", type = SqlType.VARCHAR, size = 32, comment = "刷新token")
    private String refreshToken;

    @_DDL_Column(name = "err_msg", type = SqlType.VARCHAR, size = 200, comment = "错误原因")
    private String errMsg;

    @_DDL_Column(name = "extra", type = SqlType.MEDIUMTEXT, comment = "商户开户的信息")
    private String extra;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

    @_DDL_Column(name = "login_time", type = SqlType.TIMESTAMP, comment = "登录时间")
    private java.sql.Timestamp loginTime;

    @_DDL_Column(name = "logo_id", type = SqlType.VARCHAR, size = 32, comment = "")
    private String logoId;

    @_DDL_Column(name = "type", type = SqlType.TINYINT, nullable = false, comment = "")
    private Integer type;

    @_DDL_Column(name = "industry_code", type = SqlType.CHAR, size = 2, comment = "")
    private String industryCode;

}
